2012-10-31 - 5173.200 - Enhancement - SA200 Redesign #CrystalReportsSupport

ENHANCEMENT

5173.200 - SA200 Redesign

Requirement Summary

---

Need to change the datasource connection from BW query to MDX connection for SA200 report, for improving the query performance.

Admin Info

---

Purpose	SA200 Redesign
Requested By	Mark Harris
Spec Created By	Praveen Guntuka
Spec Created Date	10-31-2012
Spec QA by	Uday Kumar P
Objects	SA200 Crystal Report
Document Status	Complete

References

---

Prior Tickets

None

Documents

None

Functional Requirement

---

Need to change the connection from BW query connection to MDX connection for SA200 report, for improving the query performance in BO Edge Server.

Solution Summary

---

Need to change the connection from MDX driver to BW query driver using Set Datasource location Option in Crystal designer tool.

Test Plan

SNo	Test Scenario	Expected Results
1	Scheduling the Report in NEC Infoview after changing the connection.	Report should execute succesfully in NEC infoview after the changes.
2	Validating the new Report with NEC Production Report.	Report validation should be successful against the production report.

Solution Details

---

Step 1: Need to change the BW driver query to MDX driver query using 'Set Datasource Location' option in Crystal Report designer.
Step 2: Map all the fields in old and new report using the 'Map Fields' window.
Step 3: Change the formulas used as required for the MDX connection.
Step 4: Save the new SA200 in NEC Infoview under IT > BMS > Development > BW to MDX folder.
Step 5: Execute the report and validate it with the actual production report.
Step 6: Notify NEC if the report is successfully validated, so that they can overwrite the production report in appropriate folder.

Issues

---

None